Access 2007 - Action Queries and Advanced Query Options
      The "Access 2007 - Action Queries and Advanced Query Options" lesson covers the following topics:
  • Queries
  • Action Queries
  • Advanced Query Options
      
      Queries      
      Upon successful completion you will be able to:

1. Create Simple Queries;
2. Sort within Queries;
3. Use Grouping in Queries;
4. Join Tables;
5. Use Arithmetical Operators;
6. Use Logical Operators.
7. Use Wildcard Characters;
8. Create Top Values Queries;
9. Create Crosstab Queries.		      
      Action Queries      
      Upon successful completion you will be able to:

1. Understand Action Queries;
2. Create Make Table Queries;
3. Create Update Queries;
4. Create Append Queries;
5. Create Delete Queries;
6. Modify Existing Queries.		      
      Advanced Query Options      
      Upon successful completion you will be able to:

1. Understand Advanced Table Joins;
2. Modify Table Joins;
3. Create a Table Alias;
4. Create Self Joins;
5. Create Query based Queries;
6. Use NOT and NULL Operators;
7. Create Parameter Queries;
8. Create Find Duplicate Queries;
9. Create Find Unmatched Queries.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Access 2007 - Action Queries and Advanced Query Options :
Program Training Courses - Microsoft Access 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters